﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[proc_WorkLog_GetItem]
(
	@GID VARCHAR(50)
)
AS
BEGIN

	SELECT *
	,(SELECT company.CompanyName FROM Company WHERE company.Id=worklog.CompanyId) AS CompanyName
	,(SELECT Department.DName FROM Department WHERE Department.Id=worklog.DepId) AS DepName
	 FROM WorkLog WHERE GID=@GID

END
